Course content
6 units · 26 entries
-
I
Introduction & Relational Databases
- 01 Lecture-1: Introduction to Databases Download
- 02 Lecture-2: Introduction to Database, Database users, characteristics and advantages of the database, Database systems, Concepts and architecture-Data models Download
- 03 Lecture-3: Schemas, Instances & States, Three-Schema Architecture, and Data Independence. Download
- 04 Lecture-4: DBMS Languages & Interfaces - DDL, DML, DCL, TCL, High-Level vs Low-Level Languages, DBMS Interfaces, System Utilities, and Component Modules Download
- 05 Lecture-5: Integrity Constraints in DBMSUnderstanding and implementing domain, key, entity, and referential integrity constraints in database systems Download
- 06 Lecture-6: EER Diagram & Reduction to TablesUnderstanding Extended Entity-Relationship (EER) modeling, specialization, generalization, and converting EER diagrams to relational tables Download
- 07 Lecture-7: Relational Algebra & Relational CalculusComprehensive coverage of relational algebra operations and relational calculus for database querying, including set operations, joins, and division Download
- 08 Lecture-8: Database Anomalies and DependenciesUnderstanding and resolving database anomalies through functional, multivalued, and join dependencies, and their role in database normalization Download
- 09 Lecture-9: Normal Forms & Limitations of Relational Data ModelUnderstand Normalization and Limitations of Relational Data Model Download
-
II
Transaction Management
- 01 Lecture-10: Introduction to TransactionsUnderstanding transaction concepts, ACID properties, transaction states, and concurrency control in database systems Download
- 02 Lecture-11: Concurrency Control Protocols & DeadlocksExploring concurrency control mechanisms, two-phase locking, timestamp ordering, and deadlock handling in database systems Download
- 03 Lecture-12: Query OptimizationUnderstanding query processing, cost-based optimization, and query execution plans in database systems Download
-
III
Storage & Indexing
- 01 Lecture-13: File Organization and IndexingUnderstanding file organization techniques (heap, sequential, hash), indexing concepts, primary indexes, and performance analysis with practical calculations Download
- 02 Lecture-14: Clustering and Secondary IndexingDeep dive into clustering indexes, secondary indexes, dense vs sparse indexing, with practical examples and performance calculations Download
- 03 Lecture-15: Tree-Based IndexingDeep dive into B-Tree & B+ Tree Download
- 04 Lecture-16: Hash-Based IndexingUnderstanding static, extendible, and linear hashing techniques with practical examples and performance analysis Download
-
IV
Distributed & NoSQL Databases
- 01 Lecture-23: Introduction to Distributed Databases, Key Characteristics, Need for Distributed DBMS & Architecture Download
- 02 Lecture-24: Data Fragmentation in Distributed Databases Download
- 03 Lecture-25: Query Processing in Distributed Databases: Query Decomposition, Data Localization, Distributed Query Processing, Transaction Management & Concurrency Control Download
- 04 Lecture-26: NoSQL Databases: Overview & Comparison(Overview, Types, Use Cases & Comparison with RDBMS) Download
-
V
Dimensional Database Design
- 01 Lecture-17: Introduction to Data WarehousingUnderstanding the fundamentals of data warehousing, OLTP vs OLAP, data warehouse architectures, and dimensional modeling concepts Download
- 02 Lecture-18: Dimensional Database DesignExploring dimensional modeling concepts, star schema, snowflake schema, fact constellation, and OLAP cube operations Download
- 03 Lecture-19: ETL Processing & AggregatesUnderstanding ETL (Extract, Transform, Load) processes, Slowly Changing Dimensions (SCD), and implementing aggregation strategies for performance optimization Download
- 04 Lecture-20: Star Schema & Snowflake SchemaUnderstanding dimensional modeling concepts, star and snowflake schemas, and their applications in data warehousing Download
- 05 Lecture-21: Knowledge Discovery in DatabasesUnderstanding knowledge discovery in databases, data mining concepts, and their applications in database systems Download
-
VI
Case Studies and Projects
- 01 Lecture-22: Real-World Database ApplicationsExploring real-world database applications, case studies, and project implementation strategies in database systems Download